﻿CREATE TABLE [dbo].[ClaimPayments]
(
[ClaimPaymentIDKey] [int] NOT NULL IDENTITY(1, 1),
[ClaimIDKey] [int] NULL,
[ClaimSubmitterID] [nvarchar] (38) NULL,
[TransactionHandlingCode] [nvarchar] (2) NULL,
[TotalActualProviderPaymentAmount] [money] NULL,
[CreditOrDebitFlagCode] [nvarchar] (1) NULL,
[PaymentMethodCode] [nvarchar] (3) NULL,
[PaymentFormatCode] [nvarchar] (10) NULL,
[SenderDepositoryFinancialInstitutionDFIQualifier] [nvarchar] (2) NULL,
[SenderDFIIdentifier] [nvarchar] (12) NULL,
[SenderAccountNumberQualifier] [nvarchar] (3) NULL,
[SenderBankAccountNumber] [nvarchar] (35) NULL,
[PayerIdentifier] [nvarchar] (10) NULL,
[OriginatingCompanySupplementalCode] [nvarchar] (9) NULL,
[ReceiverDepositoryFinancialInstitutionDFIQualifier] [nvarchar] (2) NULL,
[ReceiverOrProviderBankIDNumber] [nvarchar] (12) NULL,
[ReceiverAccountNumberQualifier] [nvarchar] (3) NULL,
[ReceiverOrProviderAccountNumber] [nvarchar] (35) NULL,
[CheckIssueOrEFTEffectiveDate] [datetime] NULL,
[TraceTypeCode] [nvarchar] (2) NULL,
[CheckOrEFTTraceNumber] [nvarchar] (30) NULL,
[ProductionDate] [datetime] NULL,
[ProviderSummaryProviderIdentifierAssignedNumber] [nvarchar] (6) NULL,
[ProviderSummaryProviderIdentifier] [nvarchar] (30) NULL,
[ProviderSummaryFacilityTypeCode] [nvarchar] (2) NULL,
[ProviderSummaryFiscalPeriodDate] [nvarchar] (50) NULL,
[ProviderSummaryTotalClaimCount] [int] NULL,
[ProviderSummaryTotalClaimChargeAmount] [money] NULL,
[ProviderSummaryTotalCoveredChargeAmount] [money] NULL,
[ProviderSummaryTotalNoncoveredChargeAmount] [money] NULL,
[ProviderSummaryTotalDeniedChargeAmount] [money] NULL,
[ProviderSummaryTotalProviderPaymentAmount] [money] NULL,
[ProviderSummaryTotalInterestAmount] [money] NULL,
[ProviderSummaryTotalContractualAdjustmentAmount] [money] NULL,
[ProviderSummaryTotalGrammRudmanReductionAmount] [money] NULL,
[ProviderSummaryTotalMSPPayerAmount] [money] NULL,
[ProviderSummaryTotalBloodDeductibleAmount] [money] NULL,
[ProviderSummaryTotalNonLabChargeAmount] [money] NULL,
[ProviderSummaryTotalCoinsuranceAmount] [money] NULL,
[ProviderSummaryTotalHCPCSReportedChargeAmount] [money] NULL,
[ProviderSummaryTotalHCPCSPayableAmount] [money] NULL,
[ProviderSummaryTotalDeductibleAmount] [money] NULL,
[ProviderSummaryTotalProfessionalComponentAmount] [money] NULL,
[ProviderSummaryTotalMSPPatientLiabilityMetAmount] [money] NULL,
[ProviderSummaryTotalPatientReimbursementAmount] [money] NULL,
[ProviderSummaryTotalPIPClaimCount] [int] NULL,
[ProviderSummaryTotalPIPAdjustmentAmount] [money] NULL,
[ProviderSummaryTotalDRGAmount] [money] NULL,
[ProviderSummaryTotalFederalSpecificAmount] [money] NULL,
[ProviderSummaryTotalHospitalSpecificAmount] [money] NULL,
[ProviderSummaryTotalDisproportionateShareAmount] [money] NULL,
[ProviderSummaryTotalCapitalAmount] [money] NULL,
[ProviderSummaryTotalIndirectMedicalEducationAmount] [money] NULL,
[ProviderSummaryTotalOutlierDayCount] [int] NULL,
[ProviderSummaryTotalDayOutlierAmount] [money] NULL,
[ProviderSummaryTotalCostOutlierAmount] [money] NULL,
[ProviderSummaryAverageDRGLengthOfStay] [int] NULL,
[ProviderSummaryTotalDischargeCount] [int] NULL,
[ProviderSummaryTotalCostReportDayCount] [int] NULL,
[ProviderSummaryTotalCoveredDayCount] [int] NULL,
[ProviderSummaryTotalNoncoveredDayCount] [int] NULL,
[ProviderSummaryTotalMSPPassThroughAmount] [money] NULL,
[ProviderSummaryAverageDRGWeight] [int] NULL,
[ProviderSummaryTotalPPSCapitalFSPDRGAmount] [money] NULL,
[ProviderSummaryTotalPPSCapitalHSPDRGAmount] [money] NULL,
[ProviderSummaryTotalPPSDSHDRGAmount] [money] NULL,
[PatientControlNubmer] [nvarchar] (38) NULL,
[ClaimStatusCode] [nvarchar] (2) NULL,
[TotalClaimChargeAmount] [money] NULL,
[ClaimPaymentAmount] [money] NULL,
[PatientResponsibilityAmount] [money] NULL,
[ClaimFilingIndicatorCode] [nvarchar] (2) NULL,
[PayerClaimControlNumber] [nvarchar] (30) NULL,
[FacilityTypeCode] [nvarchar] (2) NULL,
[ClaimFrequencyCode] [nvarchar] (2) NULL,
[DRGCode] [nvarchar] (4) NULL,
[DRGWeight] [nvarchar] (15) NULL,
[DischargeFraction] [nvarchar] (10) NULL,
[ClaimAdjustmentGroupCode] [nvarchar] (2) NULL,
[AdjustmentReasonCode1] [nvarchar] (5) NULL,
[AdjustmentAmount1] [money] NULL,
[AdjustmentQuantity1] [int] NULL,
[AdjustmentReasonCode2] [nvarchar] (5) NULL,
[AdjustmentAmount2] [money] NULL,
[AdjustmentQuantity2] [int] NULL,
[AdjustmentReasonCode3] [nvarchar] (5) NULL,
[AdjustmentAmount3] [money] NULL,
[AdjustmentQuantity3] [int] NULL,
[AdjustmentReasonCode4] [nvarchar] (5) NULL,
[AdjustmentAmount4] [money] NULL,
[AdjustmentQuantity4] [int] NULL,
[AdjustmentReasonCode5] [nvarchar] (5) NULL,
[AdjustmentAmount5] [money] NULL,
[AdjustmentQuantity5] [int] NULL,
[ProcessingDate] [datetime] NULL,
[PatientIdentifier] [nvarchar] (80) NULL,
[SubscriberIdentifier] [nvarchar] (80) NULL,
[CorrectedInsuredIdentificationIndicator] [nvarchar] (80) NULL,
[ClaimDate] [nvarchar] (8) NULL,
[RenderingProviderIdentifier] [nvarchar] (80) NULL,
[TransactionSetControlNumber] [nvarchar] (9) NULL,
[SubscriberHierarchicalIDNumber] [int] NULL,
[InterchangeControlNumber] [nvarchar] (9) NULL,
[GroupControlNumber] [nvarchar] (9) NULL,
[AssignedNumber] [int] NULL,
[BTSMessageID] [nvarchar] (100) NULL,
[BTSInterchangeID] [nvarchar] (100) NULL
) ON [PRIMARY]


